
use pamd;

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Address]') AND type in (N'U'))
DROP TABLE [Address]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Country]') AND type in (N'U'))
DROP TABLE [Country]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Listing]') AND type in (N'U'))
DROP TABLE [Listing]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ListingFeature]') AND type in (N'U'))
DROP TABLE [ListingFeature]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ListingPhoto]') AND type in (N'U'))
DROP TABLE [ListingPhoto]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ListingPrice]') AND type in (N'U'))
DROP TABLE [ListingPrice]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Occupation]') AND type in (N'U'))
DROP TABLE [Occupation]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Registration]') AND type in (N'U'))
DROP TABLE [Registration]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[UserDetail]') AND type in (N'U'))
DROP TABLE [UserDetail]
GO


